# 插入行，插入列
from openpyxl import load_workbook
wb = load_workbook("test2.xlsx")
ws = wb.worksheets[0]
print(ws.title)
ws.insert_rows(2,3) # 第2行之前插入了3个空行
ws.insert_cols(2,3)  #第2列左边插入3个空列
wb.save("test2.xlsx")
